Adding calculations to fields
To add a calculation to a field:
- Open the report or form to which you want to add the calculation.
- On the toolbar, click the Calculations button.
- In the Calculated Fields window, locate the Calculation text box, then click the drop-down arrow.
-
In the Global Calculated Fields lookup window, locate and double-click the calculation you want to insert.
Important! The list is much longer than it looks because there is no vertical scroll bar. To locate your calculation, type the first few letters of its name.
- Click the Add button, then click OK.
-
You return to the Form/Report Page Design window.
Important! If you see an unable to save message, click OK and verify that the calculation has been added.
- Create a text box where you want to add the calculated field.
- On the Insert menu, click Fields.
- In the Insert Fields window, find and select Calculated Fields.
- In the Fields list, double-click the field you want to insert.
- Click > .